SELECT
o.obqva_id AS o_id,
oo.ime AS o_ime,
img.img_id AS i_id,
img.ifile AS ifile,
img.width_sr AS iw,
img.height_sr AS ih,
img.width_th AS itw,
img.height_th AS ith,
sp.selishte_id,
sp.ime,
oo.opis_txt AS o_descr,
o.tip_id AS o_tip,
ooe.ime AS e_ime,
ooe.opis_txt AS e_descr,
o.cena AS o_c,
o.cena_ot AS o_co,
o.cena_zakvm AS o_ckvm,
o.cena_otdo AS o_cotdo,
v.akronim AS v_akr,
o.text_id AS o_tid,
o.kvadratura AS o_k,
o.kvadratura_min AS o_km,
o.valuta_id AS o_valuta,
oo.url AS o_url,
o.aktivnost AS o_akt
FROM
obqva o
LEFT JOIN
obqva_opisanie oo
ON o.obqva_id=oo.obqva_id AND oo.ezik_id=2
LEFT JOIN
obqva_opisanie ooe
ON o.obqva_id=ooe.obqva_id AND ooe.ezik_id=2
LEFT JOIN
obqva_img oi
ON o.obqva_id = oi.obqva_id AND oi.red = 1
LEFT JOIN
img img
ON oi.img_id = img.img_id
LEFT JOIN
obqva_selishte os ON os.obqva_id = o.obqva_id
LEFT JOIN
selishte s
ON s.selishte_id = os.selishte_id
LEFT JOIN
selishte sup
ON s.selishte_up_id = sup.selishte_id
LEFT JOIN
obqva_imot oim
ON oim.obqva_id = o.obqva_id
LEFT JOIN
selishte_prevod sp
ON s.selishte_id = sp.selishte_id AND sp.ezik_id = 2
LEFT JOIN
valuta v
ON o.valuta_id=v.valuta_id
WHERE
o.publikuvaj = 1 AND oim.imot_id IN (48,49,50,51,47) ORDER BY o.aktivnost, o.data_aktualizaciq DESC
#23 - Out of resources when opening file '/tmp/#sql_6f4c_685.MYI' (Errcode: 24)
|